Databases store data in records. People read reports. To present your ideas effectively, you must analyze your data and transform it into a report. In the past, data analysis was nearly impossible unless you created complex macros, wrote syntax-based report commands, or even re-keyed data. DataPivot brings your data into a dynamic analysis and reporting environment with just a few simple mouse clicks.
Analyze data dynamically
DataPivot combines power and flexibility with instant feedback. As you alter the structure of a report, DataPivot dynamically re-calculates data values as they fall into place. DataPivot replaces old-fashioned reporting tools which worked in the abstract: first you specified the structure of a report, then you waited for the data. If the report didn╒t reveal the information you needed, you had to start all over again, and again, and again.
Follow logical analysis
DataPivot helps you follow an analytical thread to its conclusion without interruptions for coding, re-coding or waiting for the report to run. Explore numbers and ideas in an unlimited number of ways; DataPivot transforms the drudgery of reworking, rethinking, and re-analyzing data into a dynamic, visual process, transforming your data into information. DataPivot provides answers as quickly as you can think of questions.
Use query or spreadsheet data
DataPivot uses standard files created by other applications such as spreadsheets, databases and query tools. DataPivot imports any rectangular, tabular, text/numeric file created with the following formats: SYLK, BIFF, WKS, and tab- or comma-delimited.
Build reports interactively
DataPivot graphically positions and rearranges your data however you want╤it even interchanges rows and columns on the fly. Indicate which data elements will be rows or columns in a report by clicking on source data columns and then choosing the appropriate report layout area. ╥Pivot╙ data axes to view data from a variety of perspectives. DataPivot rearranges source data without any retyping, so you can produce multiple views of your data in seconds, not hours.
Create your own groups
DataPivot combines related objects for analysis when you ╥paper clip╙ them together; select row or column labels and push the Paper Clip icon. DataPivot remembers the original values of all grouped labels so you can ungroup them with a second push of the Paper Clip icon.
Limit data shown in the report
Limit your report to certain value ranges to exclude redundant and/or unnecessary values that might otherwise make your report inaccurate. Choose subsets of your source data based on one or more source data columns, i.e. particular year(s), product, division, city, etc.
Eliminate unneeded data
During your analysis you may determine that certain report element are unnecessary to the results you want to report. Remove data labels, facts, and totals from reports by selecting them and pushing the Trash Can icon. Bring the element back by dragging it out of the data source window and back into the report.
Enhance the look of your report
You can format all aspects of your report before you print or export it. Use the Print Preview window to change or add: font types, styles and sizes, margins, page breaks, titles, subtitles, headings, footers, and grid lines. Export your data to a page layout program for more extensive formatting or graphics.
Save your work
DataPivot builds reusable report templates with multiple fonts and formats. To update the data in your report, re-import or re-subscribe to the source data; DataPivot places the new data where it belongs. Even when the number of records grows or shrinks, DataPivot always places the data in the proper positions.
Export data in any format
After you arrange your data, DataPivot provides multiple output formats: printing directly from DataPivot, exporting to spreadsheet or text files, copying results into other applications via the clipboard, publishing the information to an edition file in System 7 environments, and hot linking to other applications using DDE in a Microsoft Windows environment.
Apple¿ system requirements
DataPivot for Macintosh requires Apple╒s System 6.0.7 or later running on an Apple Macintosh Plus¿ or later series computer, with a minimum of 2 MB of RAM. DataPivot is System 7 compatible, and supports all Apple Macintosh compatible printers. Integration with DataPrism requires DataPrism 1.7 or later and Macintosh System 7.
Windows¿ system requirements
DataPivot for Windows requires Microsoft╒s Windows 3.1 with a minimum of 2 MB of RAM. A mouse and a color monitor are required. DataPivot supports any MS Windows compatible laser printer.
About Brio Technology, Inc.
Founded in 1984, Brio Technology, Inc. is committed to building cross-platform desktop software to access, integrate and analyze data anywhere. Brio also produces DataPrism¿, a database query tool for quick and easy access to data in host databases. Using Brio products to query, report, and update information, business professionals gain timely access to critical information. Brio applications have become standard additions to business productivity software, augmenting and enhancing spreadsheets, word processors, and communications products.